Displaying and editing matrices

Visum provides various options for displaying and editing matrices or using them for calculations.

Functions used to display and analyze matrices

Highlighting matrix sections in color

Showing matrix values in an aggregated form

Filtering matrix values

Displaying matrix values as a histogram

Comparing matrices graphically in pairs

Visum offers both simple and more complex operations for editing and calculating matrices. Most operations can be performed directly in the Matrix editor (User Manual: Managing, showing and analyzing matrices), others are available as functions in formulas (User Manual: Creating a matrix calculated from a formula) or as procedures (User Manual: Setting the procedure sequence).

Functions for copying / replacing matrix values

Matrix editor

Formulas

Edit individual matrix values interactively

X

 

Set values conditionally

X

X

Form constant matrix

X

X

Transpose

X

X

Reflect upper or lower triangle

X

X

Set diagonal

X

X

Copy diagonal to clipboard / Paste diagonal from clipboard

X

 

Arithmetic operations on matrices

Matrix editor

Formulas

Round (to value to be specified)

X

 

Round (to number of decimal places to be specified)

 

X

Floor (to integer)

 

X

Ceil (to integer)

 

X

Truncate (to number of decimal places to be specified)

 

X

Add / subtract matrices

X

X

Multiply / divide matrices (element-wise)

X

X

Form reciprocal (element-wise)

X

X

Raise to power (element-wise)

X

X

Take logarithm (element-wise)

X

X

Exponential function (element-wise)

X

X

Forming maximum or minimum

X

X

Symmetrize matrix (calculate average values pairwise from top and bottom triangle)

X

X

MSA (Method of Successive Averages)

X

X

GEH statistics

X

X

Arithmetic operations on matrices

Matrix editor Procedure

Projection: various procedures

X

 

Projection by territory

X

 

Calculate matrix using marginal totals, i.e. trip distribution (Gravity model calculation)

 

X

Generate main zone matrix from a zone matrix (aggregate) and generate zone matrix from a main zone matrix (disaggregate)

X

X

Arithmetic operations with two or more matrices

Matrix editor

Formulas

Sum of multiple matrices (for each element)

x*

X

Product of multiple matrices (for each element)

x*

X

Minimum of multiple matrices (for each element)

x*

X

Maximum of multiple matrices (for each element)

x*

X

Average of multiple matrices (for each element)

x*

X

* via Combination of matrices and vectors symbol 

Functions for structural changes to matrices

Matrix editor

Procedure

Extend matrix (include new OD pairs in matrix for arithmetic operations)

 

X

Aggregate / disaggregate (summarize rows/columns of a matrix)

 

X

Split/Extend (rows/columns of a matrix into/to several ones)

X

 

Form partial matrix (non-symmetric aggregation)

X

 

You can use formulas to have some matrices calculated automatically and then use them in your model (Using calculated matrices)